const express = require("express");
const router = express.Router();
var connection = require('../db/sql.js')
//缴费记录的添加
router.get('/paymentadd', function(req, res, next) {
	console.log("11",req.query)
	let {
	name,
	time,
	money,
	administrative
	} = req.query;
	connection.query(
		`insert into payment (name,time,money,administrative) values ("${name}","${time}",${money},"${administrative}")`,
		function(error, results) {
			if (error) throw error
			res.send({
				data: results
			})
		})
})